package com.jiuwu.spring.eshop.respository;

import com.jiuwu.spring.eshop.db.entity.SuperTypeWrapper;
import com.jiuwu.spring.eshop.db.entity.VType;
import org.springframework.data.domain.Sort;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface VTypeRepository extends BaseRepository<VType,Integer> {


    @Query("select u.superId AS superId,u.superType AS superType from VType u group by u.superId,u.superType  order by  u.superType")
    public List<SuperTypeWrapper> findAllGroupBySuperId();


    public List<VType> findBySuperId(Integer superId);





}
